package org.jeecg.modules.basedata.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.entity.basedata.BaseArea;
import org.jeecg.entity.basedata.HouseHolde;
import org.jeecg.entity.charge.ChargeBills;

import java.util.List;

/**
 * @Description: 区域
 * @Author: jeecg-boot
 * @Date:   2019-06-14
 * @Version: V1.0
 */
public interface BaseHouseHoldeMapper extends BaseMapper<BaseArea> {

    public List<HouseHolde> getHouseholdList(@Param("page") Page<HouseHolde> page,@Param("houseHolde") HouseHolde houseHolde);

    public List<HouseHolde> getHouseholdList(@Param("houseHolde") HouseHolde houseHolde);

    @Select("SELECT id FROM base_customer WHERE room_id= #{roomId} and del_flag='0'")
    String selectByCustomerId(@Param("roomId") String roomId);

    public ChargeBills getMaxDateInBills(@Param("customerId") String customerId);
}
